<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:1400px"/></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:1400px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Cost Awareness</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Capacity and Costs)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Top 10 Applications" name="Combination Chart1" depth="50">
																										<v2_combinationTypeTooltips/>
																										<v2_legend>
																											<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
																										<v2_commonAxis>
																											<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="15">
																												<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels></v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Application"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Provisioned (TB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																													<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Provisioned Cost"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="$###,### K"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange scale="linear">
																													<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
																												</v2_axisRange>
																												<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="$###,### K"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<CSS value="width:450px;height:250px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																										<v2_topRightAxis><v2_axis>
																												<v2_axisRange scale="linear">
																													<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
																												</v2_axisRange>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																														<CSS value="color:#454545"/>
																														<dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style>
																												</v2_axisLabels>
																												<v2_majorGridlines lineColor="#E9E9E9" lineWeight="0" lineStyle="dash"/>
																											</v2_axis>
																											<v2_combinationChartTypes><v2_bar seriesType="absolute" borders="hide" setOrdinalWidthScale="40" barShape="box"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Provisioned (TB)"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Provisioned (TB)"/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_solidPalette>
																														<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																													</v2_bar></v2_combinationChartTypes></v2_topRightAxis></v2_combinationChart>
																								</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 Business Units</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Capacity and Costs)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Top 10 Business Units" name="Combination Chart2" depth="50">
																										<v2_combinationTypeTooltips/>
																										<v2_legend>
																											<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
																										<v2_commonAxis>
																											<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="15">
																												<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels></v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Business Unit"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Total Provisioned (TB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																													<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Provisioned Cost"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="$###,### K"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange scale="linear">
																													<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
																												</v2_axisRange>
																												<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="$###,### K"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<CSS value="width:450px;height:250px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																										<v2_topRightAxis><v2_axis>
																												<v2_axisRange scale="linear">
																													<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
																												</v2_axisRange>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																														<CSS value="color:#454545"/>
																														<dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style>
																												</v2_axisLabels>
																												<v2_majorGridlines lineColor="#E9E9E9" lineWeight="0" lineStyle="dash"/>
																											</v2_axis>
																											<v2_combinationChartTypes><v2_bar seriesType="absolute" borders="hide" setOrdinalWidthScale="40" barShape="box"><v2_solidPalette>
																														<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																													<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Provisioned (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar></v2_combinationChartTypes></v2_topRightAxis></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Allocated Costs Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart7" refQuery="Chargeback Trending">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="yy/MM"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Allocated Cost"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="$###,### K"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:450px;height:250px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Costs of IOpS)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Top 10 Cost per IOpS - ETL" name="Combination Chart3" depth="50">
																										<v2_combinationTypeTooltips/>
																										<v2_legend>
																											<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
																										<v2_commonAxis>
																											<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="15">
																												<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels></v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Application"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Cost/IOpS"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																													<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Cost/IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange scale="linear">
																													<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
																												</v2_axisRange>
																												<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><currencyFormat/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<CSS value="width:688px;height:250px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																										</v2_combinationChart>
																								</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 Business Units</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Costs of IOpS)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Top 10 Cost per IOpS - ETL" name="Combination Chart4" depth="50">
																										<v2_combinationTypeTooltips/>
																										<v2_legend>
																											<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
																										<v2_commonAxis>
																											<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="15">
																												<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels></v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Business Unit"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Cost/IOpS"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																													<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Cost/IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange scale="linear">
																													<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
																												</v2_axisRange>
																												<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><currencyFormat/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<CSS value="width:688px;height:250px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																										</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-top:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Cost Awareness Detail</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														
																								<list horizontalPagination="true" name="List1" refQuery="All Apps - ETL" rowsPerPage="5000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Business Unit/LOB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit/LOB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tier"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Tier"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Capacity GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Capacity GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Used GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Used GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Cost per GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Cost per GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="IOpS Capability"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="IOpS Capability"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Disk Count"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Disk Count"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Total IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Max Total IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Max Total IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Cost"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Cost/IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat pattern="$###,###.##"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Cost/IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 10px 10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>5.2 Cost Awareness</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 1"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Raw Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Raw Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 2"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Usable Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Usable Change] &gt;0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 3"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Internal Volume Allocated Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Internal Volume Allocated Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 4"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Volume Allocated Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Volume Allocated Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 5"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Used Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Used Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 6"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Free Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Free Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle></namedConditionalStyles><queries><query name="Chargeback Detail">
			<source>
				
			<sqlQuery name="SQL7" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
        x.Tenant as 'Tenant',
        x.LineofBusiness as 'Line of Business',
        x.BusinessUnit as 'Business Unit',
        x.Project as 'Project',
        x.Application as 'Application',
        x.Host as 'Host',
        IF(x.OS LIKE CONCAT('%','Windows','%'), 'Windows', 
        IF(x.OS LIKE CONCAT('%','Linux','%'), 'Linux', null )) as 'OS', 
                  
        x.Type as 'Host Type',
        x.Processors as 'Processors',
 

CASE 
	WHEN x.Processors=1 THEN 't2.small'
	WHEN x.Processors&lt;=2 THEN 'm4.large'
	WHEN x.Processors&lt;=4 THEN 'm4.xlarge'
	WHEN x.Processors&lt;=8 THEN 'm4.2xlarge'
	WHEN x.Processors&lt;=16 THEN 'm4.4xlarge'
	WHEN x.Processors&lt;=40 THEN 'm4.10xlarge'            
	ELSE IF(x.Processors is null, null, 'm4.16xlarge')
        END AS 'ConfiguredAs',


       x.Memory as 'Memory',
        x.provTB AS 'Total Provisioned (TB)',
        x.provGB as 'Total Provisioned (GB)',
		SUM(x.cost) AS 'Total Provisioned Cost',
		
		IF(x.Type='Physical', SUM(x.cost), 0) as 'Physical Compute Cost',
	IF(x.Type='Virtual', SUM(x.cost), 0) as 'Virtual Compute Cost'
	
FROM 	(
	SELECT 	
	
	        total.Tenant,
	        total.LineofBusiness,
	        total.BusinessUnit,
	        total.Project,
	        total.Application,
	        total.Host as 'Host',
	        total.OS as 'OS',
	        total.Type as 'Type',
	        total.Processors as 'Processors',
	        total.memory as 'Memory',
	        SUM(total.provTB) AS provTB,
	        SUM(total.provGB) as provGB,
		SUM(total.cost) AS cost
	FROM 	(
		SELECT 	
		
		dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.host_dimension.name as 'Host',
		null as 'OS',
		null as 'Processors',
		null as 'Memory',
		
		'Physical' as 'Type',

		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS provTB,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) AS provGB,
			
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
		LEFT JOIN    dwh_capacity.host_dimension
		ON           dwh_capacity.host_dimension.tk=dwh_capacity.chargeback_fact.hosttk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		UNION
		SELECT 	

                dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.vm_dimension.name as 'Host',
		dwh_capacity.vm_dimension.os as 'OS',
		(SELECT dwh_inventory.hv_virtual_machine.processors FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Processors',
		
		(SELECT dwh_inventory.hv_virtual_machine.memory FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Memory',
		
		'Virtual' as 'Type',
		
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS provTB,
                        ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) AS provGB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.vm_capacity_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.vm_capacity_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_fact.applicationtk
		LEFT JOIN    dwh_capacity.vm_dimension
		ON           dwh_capacity.vm_dimension.tk=dwh_capacity.vm_capacity_fact.vmtk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		) total
	GROUP BY Host
	
	) X
	
	GROUP BY Host
	</sqlText>
		<mdProjectedItems><mdProjectedItem name="Tenant"/><mdProjectedItem name="Line of Business"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Project"/><mdProjectedItem name="Application"/><mdProjectedItem name="Host"/><mdProjectedItem name="OS"/><mdProjectedItem name="Host Type"/><mdProjectedItem name="Processors"/><mdProjectedItem name="ConfiguredAs"/><mdProjectedItem name="Memory"/><mdProjectedItem name="Total Provisioned (TB)"/><mdProjectedItem name="Total Provisioned (GB)"/><mdProjectedItem name="Total Provisioned Cost"/><mdProjectedItem name="Physical Compute Cost"/><mdProjectedItem name="Virtual Compute Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Tenant"><expression>IF([SQL7].[Tenant] contains 'Allegiant') THEN ('ABC Company') ELSE ([SQL7].[Tenant])</expression></dataItem><dataItem name="Line of Business"><expression>[SQL7].[Line of Business]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL7].[Business Unit]</expression></dataItem><dataItem name="Project"><expression>[SQL7].[Project]</expression></dataItem><dataItem name="Application"><expression>IF([SQL7].[Application] contains 'Allegiant') THEN ('ABC Application') ELSE ([SQL7].[Application])</expression></dataItem><dataItem name="Host"><expression>[SQL7].[Host]</expression></dataItem><dataItem name="OS"><expression>[SQL7].[OS]</expression></dataItem><dataItem name="Host Type"><expression>[SQL7].[Host Type]</expression></dataItem><dataItem name="Processors"><expression>[SQL7].[Processors]</expression></dataItem><dataItem name="Memory"><expression>[SQL7].[Memory]</expression></dataItem><dataItem name="ConfiguredAs"><expression>[SQL7].[ConfiguredAs]</expression></dataItem><dataItem name="Configured Cost" aggregate="total"><expression> 
   
      case
   when ( [OS] = 'Windows' ) then
      Case
	when ( [ConfiguredAs] = 't2.small' ) then (#prompt('t2smallWindows','float','17.16')# )
	when ( [ConfiguredAs] = 'm4.large' ) then (#prompt('m4largeWindows','float','108.92')# ) 
	when ( [ConfiguredAs] = 'm4.xlarge' )  then (#prompt('m4xlargeWindows','float','217.91')# ) 
        when ( [ConfiguredAs] = 'm4.2xlarge' ) then (#prompt('m42xlargeWindows','float','435.81')# ) 
	when ([ConfiguredAs] = 'm4.4xlarge' ) then (#prompt('m44xlargeWindows','float','871.55')# ) 
        when ( [ConfiguredAs] = 'm4.10xlarge' ) then ( #prompt('m410xlargeWindows','float','2178.90')#) 
        when ( [ConfiguredAs] = 'm4.16xlarge' ) then ( #prompt('m416xlargeWindows','float','3486.26')# ) 
	else ( 0 )
      end
    when ( [OS] = 'Linux' ) then
      Case
	when ([ConfiguredAs] = 't2.small' ) then ( #prompt('t2smallLinux','float','10.44')# )
	when ( [ConfiguredAs] = 'm4.large' ) then ( #prompt('m4largeLinux','float','41.76')# )
	when ([ConfiguredAs] = 'm4.xlarge' ) then ( #prompt('m4xlargeLinux','float','83.59')# )
        when ( [ConfiguredAs] = 'm4.2xlarge' ) then ( #prompt('m42xlargeLinux','float','167.17')# ) 
	when ( [ConfiguredAs] = 'm4.4xlarge' ) then ( #prompt('m44xlargeLinux','float','334.27')# ) 
        when ( [ConfiguredAs] = 'm4.10xlarge' ) then ( #prompt('m410xlargeLinux','float','835.70')# ) 
        when ( [ConfiguredAs] = 'm4.16xlarge' ) then ( #prompt('m416xlargeLinux','float','1337.14')# ) 
	else ( 0 )
      end
end
</expression></dataItem><dataItem name="Total Provisioned (TB)"><expression>[SQL7].[Total Provisioned (TB)]</expression></dataItem><dataItem name="Total Provisioned (GB)"><expression>[SQL7].[Total Provisioned (GB)]</expression></dataItem><dataItem name="Total Provisioned Cost" aggregate="total"><expression>[SQL7].[Total Provisioned Cost]</expression></dataItem><dataItem name="Physical Compute Cost" aggregate="total"><expression>IF([Host Type]='Physical') THEN ([Total Provisioned Cost]/1000/1000) ELSE (0)</expression></dataItem><dataItem name="Virtual Compute Cost" aggregate="total"><expression>IF([Host Type]='Virtual') THEN ([Total Provisioned Cost]/1000/1000) ELSE (0)</expression></dataItem><dataItem name="Linux Configured Cost" aggregate="total"><expression>IF([OS]='Linux') THEN ([Configured Cost]) ELSE (0)</expression></dataItem><dataItem name="Windows Configured Cost" aggregate="total"><expression>IF([OS]='Windows') THEN ([Configured Cost]) ELSE (0)</expression></dataItem></selection>
		</query><query name="Chargeback Changes">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL1" type="passThrough">
			<sqlText>SELECT 	x.provTB AS 'Total Provisioned (TB)',
	y.provTB AS 'Total Provisioned (TB) Last Month',
	CASE 	WHEN 	x.provTB &gt;= y.provTB
		THEN 	CONCAT('+', x.provTB - y.provTB)
		ELSE 	x.provTB - y.provTB
	END 	AS 	'Change in Total Provisioned (TB)',
	CASE 	WHEN 	x.provTB &gt;= y.provTB
		THEN 	CONCAT('(+', ROUND((x.provTB - y.provTB)/y.provTB * 100, 2), '%)')
		ELSE 	CONCAT('(', ROUND((x.provTB - y.provTB)/y.provTB * 100, 2), '%)')
	END 	AS 	'Percent Change in Total Provisioned (TB)',
	SUM(x.cost) AS 'Total Provisioned Cost',
	SUM(y.cost) AS 'Total Provisioned Cost Last Month',
	CASE 	WHEN 	x.cost &gt;= y.cost
		THEN 	CONCAT('+', (x.cost - y.cost))
		ELSE 	x.cost - y.cost
	END 	AS 	'Change in Total Provisioned Cost',
	CASE 	WHEN 	x.cost &gt;= y.cost
		THEN 	CONCAT('(+', ROUND((x.cost - y.cost)/y.cost * 100, 2), '%)')
		ELSE 	CONCAT('(', ROUND((x.cost - y.cost)/y.cost * 100, 2), '%)')
	END 	AS 	'Percent Change in Total Provisioned Cost'
FROM 	(
	SELECT 	SUM(total.provTB) AS provTB,
		SUM(total.cost) AS cost
	FROM 	(
		SELECT 	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS provTB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		GROUP BY
			Tier,
			dwh_capacity.date_dimension.fullDate
		UNION
		SELECT 	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS provTB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.vm_capacity_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		GROUP BY
			Tier,
			dwh_capacity.date_dimension.fullDate
		) total
	) X
JOIN 	(
	SELECT 	SUM(total.provTB) AS provTB,
		SUM(total.cost) AS cost
	FROM 	(
		SELECT 	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS provTB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.fullDate = (SELECT dwh_capacity.date_dimension.fullDate FROM dwh_capacity.date_dimension WHERE latest = 1) - INTERVAL 1 MONTH
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		GROUP BY
			Tier,
			dwh_capacity.date_dimension.fullDate
		UNION
		SELECT 	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS provTB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.vm_capacity_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.fullDate = (SELECT dwh_capacity.date_dimension.fullDate FROM dwh_capacity.date_dimension WHERE latest = 1) - INTERVAL 1 MONTH
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		GROUP BY
			Tier,
			dwh_capacity.date_dimension.fullDate
		) total
	) Y</sqlText>
		<mdProjectedItems><mdProjectedItem name="Total Provisioned (TB)"/><mdProjectedItem name="Total Provisioned (TB) Last Month"/><mdProjectedItem name="Change in Total Provisioned (TB)"/><mdProjectedItem name="Percent Change in Total Provisioned (TB)"/><mdProjectedItem name="Total Provisioned Cost"/><mdProjectedItem name="Total Provisioned Cost Last Month"/><mdProjectedItem name="Change in Total Provisioned Cost"/><mdProjectedItem name="Percent Change in Total Provisioned Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Total Provisioned (TB)"><expression>[SQL1].[Total Provisioned (TB)]</expression></dataItem><dataItem name="Total Provisioned (TB) Last Month"><expression>[SQL1].[Total Provisioned (TB) Last Month]</expression></dataItem><dataItem name="Change in Total Provisioned (TB)"><expression>[SQL1].[Change in Total Provisioned (TB)]</expression></dataItem><dataItem name="Percent Change in Total Provisioned (TB)"><expression>[SQL1].[Percent Change in Total Provisioned (TB)]</expression></dataItem><dataItem name="Total Provisioned Cost"><expression>IF([SQL1].[Total Provisioned Cost] &gt; 1000000) THEN ([SQL1].[Total Provisioned Cost]/1000/1000) ELSE ([SQL1].[Total Provisioned Cost])</expression></dataItem><dataItem name="Total Provisioned Cost Last Month"><expression>[SQL1].[Total Provisioned Cost Last Month]</expression></dataItem><dataItem name="Change in Total Provisioned Cost"><expression>[SQL1].[Change in Total Provisioned Cost]</expression></dataItem><dataItem name="Percent Change in Total Provisioned Cost"><expression>[SQL1].[Percent Change in Total Provisioned Cost]</expression></dataItem></selection>
		</query><query name="Tier or Service Level Data"><source><sqlQuery name="SQL2" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT

CASE 	
WHEN 	
dwh_capacity.service_level_dimension.tk = 0
THEN 	dwh_capacity.tier_dimension.name
ELSE 	dwh_capacity.service_level_dimension.name
END 	AS 	'Tier',

CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
THEN 	dwh_inventory.tier.cost
ELSE 	dwh_inventory.service_level.cost
END 	AS 	'Tier Cost'

		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
				
		GROUP BY
			Tier
			
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Tier"/><mdProjectedItem name="Tier Cost"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Tier"><expression>[SQL2].[Tier]</expression></dataItem><dataItem name="Tier Cost"><expression>[SQL2].[Tier Cost]</expression></dataItem></selection></query><query name="Top 10 Business Units">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
        x.Tenant as 'Tenant',
        x.LineofBusiness as 'Line of Business',
        x.BusinessUnit as 'Business Unit',
        x.Project as 'Project',
        x.Application as 'Application',
        x.Host as 'Host',
        IF(x.OS LIKE CONCAT('%','Windows','%'), 'Windows', 
        IF(x.OS LIKE CONCAT('%','Linux','%'), 'Linux', null )) as 'OS', 
                  
        x.Type as 'Host Type',
        x.Processors as 'Processors',
 

CASE 
	WHEN x.Processors=1 THEN 't2.small'
	WHEN x.Processors&lt;=2 THEN 'm4.large'
	WHEN x.Processors&lt;=4 THEN 'm4.xlarge'
	WHEN x.Processors&lt;=8 THEN 'm4.2xlarge'
	WHEN x.Processors&lt;=16 THEN 'm4.4xlarge'
	WHEN x.Processors&lt;=40 THEN 'm4.10xlarge'            
	ELSE IF(x.Processors is null, null, 'm4.16xlarge')
        END AS 'ConfiguredAs',


       x.Memory as 'Memory',
        x.provTB AS 'Total Provisioned (TB)',
        x.provGB as 'Total Provisioned (GB)',
		SUM(x.cost) AS 'Total Provisioned Cost',
		
		IF(x.Type='Physical', SUM(x.cost), 0) as 'Physical Compute Cost',
	IF(x.Type='Virtual', SUM(x.cost), 0) as 'Virtual Compute Cost'
	
FROM 	(
	SELECT 	
	
	        total.Tenant,
	        total.LineofBusiness,
	        total.BusinessUnit,
	        total.Project,
	        total.Application,
	        total.Host as 'Host',
	        total.OS as 'OS',
	        total.Type as 'Type',
	        total.Processors as 'Processors',
	        total.memory as 'Memory',
	        SUM(total.provTB) AS provTB,
	        SUM(total.provGB) as provGB,
		SUM(total.cost) AS cost
	FROM 	(
		SELECT 	
		
		dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.host_dimension.name as 'Host',
		null as 'OS',
		null as 'Processors',
		null as 'Memory',
		
		'Physical' as 'Type',

		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS provTB,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) AS provGB,
			
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
		LEFT JOIN    dwh_capacity.host_dimension
		ON           dwh_capacity.host_dimension.tk=dwh_capacity.chargeback_fact.hosttk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		UNION
		SELECT 	

                dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.vm_dimension.name as 'Host',
		dwh_capacity.vm_dimension.os as 'OS',
		(SELECT dwh_inventory.hv_virtual_machine.processors FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Processors',
		
		(SELECT dwh_inventory.hv_virtual_machine.memory FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Memory',
		
		'Virtual' as 'Type',
		
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS provTB,
                        ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) AS provGB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.vm_capacity_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.vm_capacity_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_fact.applicationtk
		LEFT JOIN    dwh_capacity.vm_dimension
		ON           dwh_capacity.vm_dimension.tk=dwh_capacity.vm_capacity_fact.vmtk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		) total
	GROUP BY businessunit
	
	) X
	
	GROUP BY x.businessunit 


	</sqlText>
		<mdProjectedItems><mdProjectedItem name="Tenant"/><mdProjectedItem name="Line of Business"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Project"/><mdProjectedItem name="Application"/><mdProjectedItem name="Host"/><mdProjectedItem name="OS"/><mdProjectedItem name="Host Type"/><mdProjectedItem name="Processors"/><mdProjectedItem name="ConfiguredAs"/><mdProjectedItem name="Memory"/><mdProjectedItem name="Total Provisioned (TB)"/><mdProjectedItem name="Total Provisioned (GB)"/><mdProjectedItem name="Total Provisioned Cost"/><mdProjectedItem name="Physical Compute Cost"/><mdProjectedItem name="Virtual Compute Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Business Unit"><expression>[SQL3].[Business Unit]</expression></dataItem><dataItem name="Total Provisioned Cost" aggregate="total"><expression>[SQL3].[Total Provisioned Cost]/1000</expression></dataItem><dataItem name="rank"><expression>rank([Total Provisioned Cost])</expression></dataItem><dataItem name="Total Provisioned (TB)" aggregate="total"><expression>[SQL3].[Total Provisioned (TB)]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Business Unit]&lt;&gt; 'N/A'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank] &lt; 11</filterExpression></detailFilter></detailFilters></query><query name="Top 10 Applications">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
               x.Application as 'Application',
      SUM(x.cost) AS 'Total Provisioned Cost',
      SUM(x.provGB) as 'Provisioned (GB)'
		

FROM 	(
	SELECT 	
	
	        total.Tenant,
	        total.LineofBusiness,
	        total.BusinessUnit,
	        total.Project,
	        total.Application,
	        total.Host as 'Host',
	        total.OS as 'OS',
	        total.Type as 'Type',
	        total.Processors as 'Processors',
	        total.memory as 'Memory',
	        SUM(total.provTB) AS provTB,
	        SUM(total.provGB) as provGB,
		SUM(total.cost) AS cost
	FROM 	(
		SELECT 	
		
		dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.host_dimension.name as 'Host',
		null as 'OS',
		null as 'Processors',
		null as 'Memory',
		
		'Physical' as 'Type',

		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS provTB,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) AS provGB,
			
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
AND	dwh_capacity.application_dimension.name NOT LIKE CONCAT('%','Allegiant','%')

		LEFT JOIN    dwh_capacity.host_dimension
		ON           dwh_capacity.host_dimension.tk=dwh_capacity.chargeback_fact.hosttk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		UNION
		SELECT 	

                dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.vm_dimension.name as 'Host',
		dwh_capacity.vm_dimension.os as 'OS',
		(SELECT dwh_inventory.hv_virtual_machine.processors FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Processors',
		
		(SELECT dwh_inventory.hv_virtual_machine.memory FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Memory',
		
		'Virtual' as 'Type',
		
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS provTB,
                        ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) AS provGB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.vm_capacity_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.vm_capacity_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_fact.applicationtk
AND	dwh_capacity.application_dimension.name NOT LIKE CONCAT('%','Allegiant','%')
		LEFT JOIN    dwh_capacity.vm_dimension
		ON           dwh_capacity.vm_dimension.tk=dwh_capacity.vm_capacity_fact.vmtk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		) total
	GROUP BY Application
	
	) X
	
	GROUP BY x.Application


	</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="Total Provisioned Cost"/><mdProjectedItem name="Provisioned (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL4].[Application]</expression></dataItem><dataItem name="Total Provisioned Cost" aggregate="total"><expression>[SQL4].[Total Provisioned Cost]/1000</expression></dataItem><dataItem name="Provisioned (TB)" aggregate="total" label="Provisioned (TB)"><expression>[SQL4].[Provisioned (GB)]/1024</expression></dataItem><dataItem name="rank"><expression>rank([Total Provisioned Cost])</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Application]&lt;&gt;'N/A'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;11</filterExpression></detailFilter></detailFilters></query><query name="Top 5 Hosts">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
        x.Tenant as 'Tenant',
        x.LineofBusiness as 'Line of Business',
        x.BusinessUnit as 'Business Unit',
        x.Project as 'Project',
        x.Application as 'Application',
        x.Host as 'Host',
        IF(x.OS LIKE CONCAT('%','Windows','%'), 'Windows', 
        IF(x.OS LIKE CONCAT('%','Linux','%'), 'Linux', null )) as 'OS', 
                  
        x.Type as 'Host Type',
        x.Processors as 'Processors',
 

CASE 
	WHEN x.Processors=1 THEN 't2.small'
	WHEN x.Processors&lt;=2 THEN 'm4.large'
	WHEN x.Processors&lt;=4 THEN 'm4.xlarge'
	WHEN x.Processors&lt;=8 THEN 'm4.2xlarge'
	WHEN x.Processors&lt;=16 THEN 'm4.4xlarge'
	WHEN x.Processors&lt;=40 THEN 'm4.10xlarge'            
	ELSE IF(x.Processors is null, null, 'm4.16xlarge')
        END AS 'ConfiguredAs',


       x.Memory as 'Memory',
        x.provTB AS 'Total Provisioned (TB)',
        x.provGB as 'Total Provisioned (GB)',
		SUM(x.cost) AS 'Total Provisioned Cost',
		
		IF(x.Type='Physical', SUM(x.cost), 0) as 'Physical Compute Cost',
	IF(x.Type='Virtual', SUM(x.cost), 0) as 'Virtual Compute Cost'
	
FROM 	(
	SELECT 	
	
	        total.Tenant,
	        total.LineofBusiness,
	        total.BusinessUnit,
	        total.Project,
	        total.Application,
	        total.Host as 'Host',
	        total.OS as 'OS',
	        total.Type as 'Type',
	        total.Processors as 'Processors',
	        total.memory as 'Memory',
	        SUM(total.provTB) AS provTB,
	        SUM(total.provGB) as provGB,
		SUM(total.cost) AS cost
	FROM 	(
		SELECT 	
		
		dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.host_dimension.name as 'Host',
		null as 'OS',
		null as 'Processors',
		null as 'Memory',
		
		'Physical' as 'Type',

		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS provTB,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) AS provGB,
			
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
		LEFT JOIN    dwh_capacity.host_dimension
		ON           dwh_capacity.host_dimension.tk=dwh_capacity.chargeback_fact.hosttk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		UNION
		SELECT 	

                dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.vm_dimension.name as 'Host',
		dwh_capacity.vm_dimension.os as 'OS',
		(SELECT dwh_inventory.hv_virtual_machine.processors FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Processors',
		
		(SELECT dwh_inventory.hv_virtual_machine.memory FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Memory',
		
		'Virtual' as 'Type',
		
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS provTB,
                        ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) AS provGB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.vm_capacity_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.vm_capacity_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_fact.applicationtk
		LEFT JOIN    dwh_capacity.vm_dimension
		ON           dwh_capacity.vm_dimension.tk=dwh_capacity.vm_capacity_fact.vmtk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		) total
	GROUP BY Host
	
	) X
	
	GROUP BY Host
	
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Tenant"/><mdProjectedItem name="Line of Business"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Project"/><mdProjectedItem name="Application"/><mdProjectedItem name="Host"/><mdProjectedItem name="OS"/><mdProjectedItem name="Host Type"/><mdProjectedItem name="Processors"/><mdProjectedItem name="ConfiguredAs"/><mdProjectedItem name="Memory"/><mdProjectedItem name="Total Provisioned (TB)"/><mdProjectedItem name="Total Provisioned (GB)"/><mdProjectedItem name="Total Provisioned Cost"/><mdProjectedItem name="Physical Compute Cost"/><mdProjectedItem name="Virtual Compute Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Tenant"><expression>[SQL5].[Tenant]</expression></dataItem><dataItem name="Line of Business"><expression>[SQL5].[Line of Business]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL5].[Business Unit]</expression></dataItem><dataItem name="Project"><expression>[SQL5].[Project]</expression></dataItem><dataItem name="Application"><expression>[SQL5].[Application]</expression></dataItem><dataItem name="Host"><expression>[SQL5].[Host]</expression></dataItem><dataItem name="OS"><expression>[SQL5].[OS]</expression></dataItem><dataItem name="Host Type"><expression>[SQL5].[Host Type]</expression></dataItem><dataItem name="Processors"><expression>[SQL5].[Processors]</expression></dataItem><dataItem name="ConfiguredAs"><expression>[SQL5].[ConfiguredAs]</expression></dataItem><dataItem name="Memory"><expression>[SQL5].[Memory]</expression></dataItem><dataItem name="Total Provisioned (TB)"><expression>[SQL5].[Total Provisioned (TB)]</expression></dataItem><dataItem name="Total Provisioned (GB)"><expression>[SQL5].[Total Provisioned (GB)]</expression></dataItem><dataItem name="Total Provisioned Cost" aggregate="total"><expression>[SQL5].[Total Provisioned Cost]/1000</expression></dataItem><dataItem name="Physical Compute Cost"><expression>[SQL5].[Physical Compute Cost]</expression></dataItem><dataItem name="Virtual Compute Cost"><expression>[SQL5].[Virtual Compute Cost]</expression></dataItem><dataItem name="rank"><expression>rank([Total Provisioned Cost])</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Host]&lt;&gt;'N/A'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;6</filterExpression></detailFilter></detailFilters></query><query name="Chargeback Trending">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL2" type="passThrough">
			<sqlText>SELECT 	x.fullDate AS 'Date',
	SUM(x.allocatedTB) AS 'Allocated (TB)',
	SUM(x.cost) AS 'Allocated Cost'
FROM 	(
	SELECT 	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
			THEN 	dwh_capacity.tier_dimension.name
			ELSE 	dwh_capacity.service_level_dimension.name
		END 	AS 	Tier,
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
			THEN 	dwh_inventory.tier.cost
			ELSE 	dwh_inventory.service_level.cost
		END 	AS 	'Tier Cost/GB',
		dwh_capacity.date_dimension.fullDate AS fullDate,
		ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS allocatedTB,
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
			THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
			ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
		END 	AS 	cost
	FROM 	dwh_capacity.chargeback_fact
	JOIN 	dwh_capacity.service_level_dimension
	ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
	AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
	JOIN 	dwh_capacity.tier_dimension
	ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1
	LEFT JOIN 	dwh_inventory.tier
	ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
	LEFT JOIN 	dwh_inventory.service_level
	ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
	
WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.chargeback_fact 
ON  dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH


	GROUP BY
		Tier,
		dwh_capacity.date_dimension.fullDate
	UNION
	SELECT 	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
			THEN 	dwh_capacity.tier_dimension.name
			ELSE 	dwh_capacity.service_level_dimension.name
		END 	AS 	Tier,
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
			THEN 	dwh_inventory.tier.cost
			ELSE 	dwh_inventory.service_level.cost
		END 	AS 	'Tier Cost/GB',
		dwh_capacity.date_dimension.fullDate AS fullDate,
		ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS allocatedTB,
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
			THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
			ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
		END 	AS 	cost
	FROM 	dwh_capacity.vm_capacity_fact
	JOIN 	dwh_capacity.service_level_dimension
	ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
	JOIN 	dwh_capacity.tier_dimension
	ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1
	LEFT JOIN 	dwh_inventory.tier
	ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
	LEFT JOIN 	dwh_inventory.service_level
	ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
	
WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.vm_capacity_fact 
ON  dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH



	GROUP BY
		Tier,
		dwh_capacity.date_dimension.fullDate
	) X
GROUP BY
	x.fullDate</sqlText>
		<mdProjectedItems><mdProjectedItem name="Date"/><mdProjectedItem name="Allocated (TB)"/><mdProjectedItem name="Allocated Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Date"><expression>[SQL2].[Date]</expression></dataItem><dataItem aggregate="total" name="Allocated (TB)"><expression>[SQL2].[Allocated (TB)]</expression></dataItem><dataItem aggregate="total" name="Allocated Cost"><expression>[SQL2].[Allocated Cost]/1000</expression></dataItem></selection>
		</query><query name="Top 10 Cost per IOpS - ETL">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL3">
			<sqlText>SELECT
cap.storage as 'Storage Name',
cap.pool as 'Pool Name',
cap.totalCapacityTB as 'Total Capacity GB',
cap.totalUsedTB as 'Total Used GB',
cap.tier as 'Tier',
cap.cost as 'Cost',
cap.businessUnit as 'Business Unit',
cap.application as 'Application',
perf.diskIOpSCapability as 'IOpS Capability',
perf.maxSupportedIOpS as 'Max Supported IOpS',
perf.diskCount as 'Disk Count',
perf.totalIOpS as 'Total IOpS',
perf.maxTotalIOpS as 'Max Total IOpS'


FROM (
SELECT
dwh_custom.app_busunit_capacity.storageName as storage,
dwh_custom.app_busunit_capacity.poolName as pool,
dwh_custom.app_busunit_capacity.allocatedCapTB*1024 as totalCapacityTB,
dwh_custom.app_busunit_capacity.usedCapTB*1024 as totalUsedTB,
dwh_custom.app_busunit_capacity.tier as tier,
dwh_custom.app_busunit_capacity.cost as cost,
IF(dwh_custom.app_busunit_capacity.busUnit='N/A', dwh_custom.app_busunit_capacity.lob, dwh_custom.app_busunit_capacity.busUnit) as businessUnit,
dwh_custom.app_busunit_capacity.application as application

FROM dwh_custom.app_busunit_capacity ) cap

LEFT JOIN

(SELECT
dwh_custom.pool_dimension.storageName as storage,
dwh_custom.pool_dimension.storagePoolName as pool,
dwh_custom.pool_dimension.tier as tier,
dwh_custom.pool_dimension.poolIopsCapability as diskIOpSCapability,
dwh_custom.pool_dimension.poolIopsCapability as maxSupportedIOpS,
dwh_custom.pool_dimension.diskCount as diskCount,
dwh_custom.pool_perf_fact.avgIOpS as totalIOpS,
dwh_custom.pool_perf_fact.maxIOpS as maxTotalIOpS

FROM	dwh_custom.pool_dimension
JOIN	dwh_custom.pool_perf_fact
ON	dwh_custom.pool_perf_fact.storagePoolId=dwh_custom.pool_dimension.storagePoolId

WHERE dwh_custom.pool_perf_fact.fulldate &gt;= (SELECT MAX(dwh_custom.pool_perf_fact.fulldate) 
FROM dwh_custom.pool_perf_fact) - INTERVAL 90 DAY
GROUP BY dwh_custom.pool_dimension.storageName, dwh_custom.pool_dimension.storagePoolName ) perf 
ON perf.storage=cap.storage AND perf.pool=cap.pool 
GROUP BY cap.application, cap.businessunit, cap.storage, cap.pool, cap.tier
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Total Capacity GB"/><mdProjectedItem name="Total Used GB"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Application"/><mdProjectedItem name="IOpS Capability"/><mdProjectedItem name="Max Supported IOpS"/><mdProjectedItem name="Disk Count"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Max Total IOpS"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL3].[Pool Name]</expression></dataItem><dataItem name="Total Capacity GB"><expression>[SQL3].[Total Capacity GB]</expression></dataItem><dataItem name="Total Used GB"><expression>[SQL3].[Total Used GB]</expression></dataItem><dataItem name="Tier"><expression>[SQL3].[Tier]</expression></dataItem><dataItem name="Cost per GB"><expression>[SQL3].[Cost]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL3].[Business Unit]</expression></dataItem><dataItem name="Application"><expression>[SQL3].[Application]</expression></dataItem><dataItem name="IOpS Capability"><expression>[SQL3].[IOpS Capability]</expression></dataItem><dataItem name="Max Supported IOpS"><expression>[SQL3].[Max Supported IOpS]</expression></dataItem><dataItem name="Disk Count"><expression>[SQL3].[Disk Count]</expression></dataItem><dataItem name="Total IOpS"><expression>[SQL3].[Total IOpS]</expression></dataItem><dataItem name="Max Total IOpS"><expression>[SQL3].[Max Total IOpS]</expression></dataItem><dataItem name="Total Cost"><expression>[Cost per GB]*[Total Capacity GB]</expression></dataItem><dataItem aggregate="total" name="Cost/IOpS"><expression>[Total Cost]/[IOpS Capability]</expression></dataItem><dataItem name="rank"><expression>rank([Cost/IOpS])</expression></dataItem></selection>
		<queryHints><localCache value="false"/></queryHints><detailFilters><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;11</filterExpression></detailFilter><detailFilter><filterExpression>[Business Unit]&lt;&gt;'N/A'</filterExpression></detailFilter><detailFilter><filterExpression>[Application]&lt;&gt;'N/A'</filterExpression></detailFilter></detailFilters></query><query name="All Apps - ETL">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL3">
			<sqlText>SELECT
cap.storage as 'Storage Name',
cap.pool as 'Pool Name',
cap.totalCapacityTB as 'Total Capacity GB',
cap.totalUsedTB as 'Total Used GB',
cap.tier as 'Tier',
cap.cost as 'Cost',
cap.businessUnit as 'Business Unit',
cap.application as 'Application',
perf.diskIOpSCapability as 'IOpS Capability',
perf.maxSupportedIOpS as 'Max Supported IOpS',
perf.diskCount as 'Disk Count',
perf.totalIOpS as 'Total IOpS',
perf.maxTotalIOpS as 'Max Total IOpS'


FROM (
SELECT
dwh_custom.app_busunit_capacity.storageName as storage,
dwh_custom.app_busunit_capacity.poolName as pool,
dwh_custom.app_busunit_capacity.allocatedCapTB*1024 as totalCapacityTB,
dwh_custom.app_busunit_capacity.usedCapTB*1024 as totalUsedTB,
dwh_custom.app_busunit_capacity.tier as tier,
dwh_custom.app_busunit_capacity.cost as cost,
dwh_custom.app_busunit_capacity.busUnit as businessUnit,
dwh_custom.app_busunit_capacity.application as application

FROM dwh_custom.app_busunit_capacity ) cap

LEFT JOIN

(SELECT
dwh_custom.pool_dimension.storageName as storage,
dwh_custom.pool_dimension.storagePoolName as pool,
dwh_custom.pool_dimension.tier as tier,
dwh_custom.pool_dimension.poolIopsCapability as diskIOpSCapability,
dwh_custom.pool_dimension.poolIopsCapability as maxSupportedIOpS,
dwh_custom.pool_dimension.diskCount as diskCount,
dwh_custom.pool_perf_fact.avgIOpS as totalIOpS,
dwh_custom.pool_perf_fact.maxIOpS as maxTotalIOpS

FROM	dwh_custom.pool_dimension
JOIN	dwh_custom.pool_perf_fact
ON	dwh_custom.pool_perf_fact.storagePoolId=dwh_custom.pool_dimension.storagePoolId

WHERE dwh_custom.pool_perf_fact.fulldate &gt;= (SELECT MAX(dwh_custom.pool_perf_fact.fulldate) 
FROM dwh_custom.pool_perf_fact) - INTERVAL 90 DAY
GROUP BY dwh_custom.pool_dimension.storageName, dwh_custom.pool_dimension.storagePoolName ) perf 
ON perf.storage=cap.storage AND perf.pool=cap.pool 
GROUP BY cap.application, cap.businessunit, cap.storage, cap.pool, cap.tier
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Total Capacity GB"/><mdProjectedItem name="Total Used GB"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Application"/><mdProjectedItem name="IOpS Capability"/><mdProjectedItem name="Max Supported IOpS"/><mdProjectedItem name="Disk Count"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Max Total IOpS"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL3].[Pool Name]</expression></dataItem><dataItem name="Total Capacity GB"><expression>[SQL3].[Total Capacity GB]</expression></dataItem><dataItem name="Total Used GB"><expression>[SQL3].[Total Used GB]</expression></dataItem><dataItem name="Tier"><expression>[SQL3].[Tier]</expression></dataItem><dataItem name="Cost per GB"><expression>[SQL3].[Cost]</expression></dataItem><dataItem name="Business Unit/LOB"><expression>[SQL3].[Business Unit]</expression></dataItem><dataItem name="Application"><expression>[SQL3].[Application]</expression></dataItem><dataItem name="IOpS Capability"><expression>[SQL3].[IOpS Capability]</expression></dataItem><dataItem name="Max Supported IOpS"><expression>[SQL3].[Max Supported IOpS]</expression></dataItem><dataItem name="Disk Count"><expression>[SQL3].[Disk Count]</expression></dataItem><dataItem name="Total IOpS"><expression>[SQL3].[Total IOpS]</expression></dataItem><dataItem name="Max Total IOpS"><expression>[SQL3].[Max Total IOpS]</expression></dataItem><dataItem name="Total Cost"><expression>[Cost per GB]*[Total Capacity GB]</expression></dataItem><dataItem name="Cost/IOpS"><expression>[Total Cost]/[IOpS Capability]</expression></dataItem></selection>
		<queryHints><localCache value="false"/></queryHints></query></queries></report>